package com.hooya.fa.eu.biz.dao.mapper.rxh;

import com.hooya.fa.eu.api.bo.LastCostBO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description 1
 * @Author : Zongz
 * @Copyright Copyright (c) 豪雅集团
 * @Create 2023/11/28
 * @Version 1.0.0
 */
@Mapper
public interface CostMapper {

    @Select("SELECT cpbh, (cbdj-logisticfee) * 1.18 lastPrice, oceanfee oceanFee FROM cost_last")
    List<LastCostBO> getMmBoList();

    @Select("SELECT cpbh, (cbdj-logisticfee) * 1 lastPrice, oceanfee oceanFee FROM cost_last")
    List<LastCostBO> getZyBoList();
}
